create procedure sp_asi_UnformatPhoneNumbers
as
     -- Name
     exec sp_asi_UnformatPhoneNumber 'Name','HOME_PHONE'
     exec sp_asi_UnformatPhoneNumber 'Name','WORK_PHONE'
     exec sp_asi_UnformatPhoneNumber 'Name','FAX'
     exec sp_asi_UnformatPhoneNumber 'Name','TOLL_FREE'
     -- Name_Address
     exec sp_asi_UnformatPhoneNumber 'Name_Address','PHONE'
     exec sp_asi_UnformatPhoneNumber 'Name_Address','FAX'
     -- Meet_Hotel
     exec sp_asi_UnformatPhoneNumber 'Meet_Hotel','PHONE'
     exec sp_asi_UnformatPhoneNumber 'Meet_Hotel','FAX'
     exec sp_asi_UnformatPhoneNumber 'Meet_Hotel','TOLL_FREE'
     -- Orders
     exec sp_asi_UnformatPhoneNumber 'Orders','PHONE'
     exec sp_asi_UnformatPhoneNumber 'Orders','FAX'
     exec sp_asi_UnformatPhoneNumber 'Orders','TOLL_FREE'
     -- Product_Instance
     exec sp_asi_UnformatPhoneNumber 'Product_Instance','PHONE'
     exec sp_asi_UnformatPhoneNumber 'Product_Instance','FAX'
     exec sp_asi_UnformatPhoneNumber 'Product_Instance','TOLL_FREE'
     -- Ref_Client
     exec sp_asi_UnformatPhoneNumber 'Ref_Client','PHONE'
     exec sp_asi_UnformatPhoneNumber 'Ref_Client','FAX'
     -- Ref_Provider
     exec sp_asi_UnformatPhoneNumber 'Ref_Provider','PHONE'
     -- Rpt_WorkingTbl
     exec sp_asi_UnformatPhoneNumber 'Rpt_WorkingTbl','WORK_PHONE'
     exec sp_asi_UnformatPhoneNumber 'Rpt_WorkingTbl','HOME_PHONE'
     -- Exhb_Srvc_Comp
     exec sp_asi_UnformatPhoneNumber 'Exhb_Srvc_Comp','CONTACT_PHONE'
     -- Contacts
     exec sp_asi_UnformatPhoneNumber 'Contacts','PHONE'
     exec sp_asi_UnformatPhoneNumber 'Contacts','FAX'

GO
GRANT EXECUTE ON  [dbo].[sp_asi_UnformatPhoneNumbers] TO [IMIS]
GO